Pandas Profiling Report: CC GENERAL

Dataset statistics

Number of variables	18
Number of observations	8950
Missing cells	314
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	199.0 B

Variable types

Categorical	1
Numeric	17

Warnings

`CUST_ID` has a high cardinality: 8950 distinct values	High cardinality
`PURCHASES` is highly correlated with `ONEOFF_PURCHASES`	High correlation
`ONEOFF_PURCHASES` is highly correlated with `PURCHASES`	High correlation
`MINIMUM_PAYMENTS` has 313 (3.5%) missing values	Missing
`CUST_ID` is uniformly distributed	Uniform
`CUST_ID` has unique values	Unique
`PURCHASES` has 2044 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES` has 4302 (48.1%) zeros	Zeros
`INSTALLMENTS_PURCHASES` has 3916 (43.8%) zeros	Zeros
`CASH_ADVANCE` has 4628 (51.7%) zeros	Zeros
`PURCHASES_FREQUENCY` has 2043 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES_FREQUENCY` has 4302 (48.1%) zeros	Zeros
`PURCHASES_INSTALLMENTS_FREQUENCY` has 3915 (43.7%) zeros	Zeros
`CASH_ADVANCE_FREQUENCY` has 4628 (51.7%) zeros	Zeros
`CASH_ADVANCE_TRX` has 4628 (51.7%) zeros	Zeros
`PURCHASES_TRX` has 2044 (22.8%) zeros	Zeros
`PAYMENTS` has 240 (2.7%) zeros	Zeros
`PRC_FULL_PAYMENT` has 5903 (66.0%) zeros	Zeros

Reproduction

Analysis started	2022-01-20 10:04:36.460087
Analysis finished	2022-01-20 10:05:41.697769
Duration	1 minute and 5.24 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

CUST_ID
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	550.8 KiB

C10665	1
C11292	1
C11499	1
C14982	1
C18903	1
Other values (8945)	8945

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	53700
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8950 ?
Unique (%)	100.0%

Sample

1st row	C10001
2nd row	C10002
3rd row	C10003
4th row	C10004
5th row	C10005

Value	Count	Frequency (%)
C10665	1	< 0.1%
C11292	1	< 0.1%
C11499	1	< 0.1%
C14982	1	< 0.1%
C18903	1	< 0.1%
C12082	1	< 0.1%
C10857	1	< 0.1%
C13324	1	< 0.1%
C13815	1	< 0.1%
C13487	1	< 0.1%
Other values (8940)	8940	99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
c14442	1	< 0.1%
c16159	1	< 0.1%
c14962	1	< 0.1%
c15183	1	< 0.1%
c13428	1	< 0.1%
c15807	1	< 0.1%
c11243	1	< 0.1%
c16000	1	< 0.1%
c18555	1	< 0.1%
c12805	1	< 0.1%
Other values (8940)	8940	99.9%

Most occurring characters

Value	Count	Frequency (%)
1	12672	23.6%
C	8950	16.7%
0	3737	7.0%
2	3652	6.8%
3	3651	6.8%
5	3642	6.8%
7	3640	6.8%
4	3636	6.8%
6	3633	6.8%
8	3633	6.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	44750	83.3%
Uppercase Letter	8950	16.7%

Most frequent character per category

Value	Count	Frequency (%)
1	12672	28.3%
0	3737	8.4%
2	3652	8.2%
3	3651	8.2%
5	3642	8.1%
7	3640	8.1%
4	3636	8.1%
6	3633	8.1%
8	3633	8.1%
9	2854	6.4%

Value	Count	Frequency (%)
C	8950	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	44750	83.3%
Latin	8950	16.7%

Most frequent character per script

Value	Count	Frequency (%)
1	12672	28.3%
0	3737	8.4%
2	3652	8.2%
3	3651	8.2%
5	3642	8.1%
7	3640	8.1%
4	3636	8.1%
6	3633	8.1%
8	3633	8.1%
9	2854	6.4%

Value	Count	Frequency (%)
C	8950	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53700	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	12672	23.6%
C	8950	16.7%
0	3737	7.0%
2	3652	6.8%
3	3651	6.8%
5	3642	6.8%
7	3640	6.8%
4	3636	6.8%
6	3633	6.8%
8	3633	6.8%

BALANCE
Real number (ℝ_≥0)

Distinct	8871
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1564.474828
Minimum	0
Maximum	19043.13856
Zeros	80
Zeros (%)	0.9%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8.81451835
Q1	128.2819155
median	873.385231
Q3	2054.140036
95-th percentile	5909.111808
Maximum	19043.13856
Range	19043.13856
Interquartile range (IQR)	1925.85812

Descriptive statistics

Standard deviation	2081.531879
Coefficient of variation (CV)	1.330498799
Kurtosis	7.6747513
Mean	1564.474828
Median Absolute Deviation (MAD)	799.865197
Skewness	2.393386043
Sum	14002049.71
Variance	4332774.965
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80	0.9%
1100.941072	1	< 0.1%
40.074484	1	< 0.1%
2093.844656	1	< 0.1%
179.765708	1	< 0.1%
12.654903	1	< 0.1%
1893.704851	1	< 0.1%
1571.218695	1	< 0.1%
31.285608	1	< 0.1%
1772.323491	1	< 0.1%
Other values (8861)	8861	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.006651	1	< 0.1%
0.009684	1	< 0.1%
0.01968	1	< 0.1%
0.021102	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

BALANCE_FREQUENCY
Real number (ℝ_≥0)

Distinct	43
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.8772707256
Minimum	0
Maximum	1
Zeros	80
Zeros (%)	0.9%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272727
Q1	0.888889
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.111111

Descriptive statistics

Standard deviation	0.2369040027
Coefficient of variation (CV)	0.2700466296
Kurtosis	3.092369622
Mean	0.8772707256
Median Absolute Deviation (MAD)	0
Skewness	-2.023265519
Sum	7851.572994
Variance	0.05612350649
Monotocity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.818182	278	3.1%
0.727273	223	2.5%
0.545455	219	2.4%
0.636364	209	2.3%
0.454545	172	1.9%
0.363636	170	1.9%
0.272727	151	1.7%
0.181818	146	1.6%
Other values (33)	761	8.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.090909	67	0.7%
0.1	8	0.1%
0.111111	5	0.1%
0.125	9	0.1%
0.142857	7	0.1%
0.166667	7	0.1%
0.181818	146	1.6%
0.2	9	0.1%
0.222222	5	0.1%

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.6%
0.857143	51	0.6%
0.833333	60	0.7%
0.818182	278	3.1%
0.8	20	0.2%
0.777778	22	0.2%

PURCHASES
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	6203
Distinct (%)	69.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1003.204834
Minimum	0
Maximum	49039.57
Zeros	2044
Zeros (%)	22.8%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.635
median	361.28
Q3	1110.13
95-th percentile	3998.6195
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1070.495

Descriptive statistics

Standard deviation	2136.634782
Coefficient of variation (CV)	2.129809098
Kurtosis	111.3887709
Mean	1003.204834
Median Absolute Deviation (MAD)	361.28
Skewness	8.144269065
Sum	8978683.26
Variance	4565208.191
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
45.65	27	0.3%
150	16	0.2%
60	16	0.2%
100	13	0.1%
300	13	0.1%
200	13	0.1%
450	12	0.1%
600	10	0.1%
70	10	0.1%
Other values (6193)	6776	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2044	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	2	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

ONEOFF_PURCHASES
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	4014
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	592.4373709
Minimum	0
Maximum	40761.25
Zeros	4302
Zeros (%)	48.1%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	38
Q3	577.405
95-th percentile	2671.094
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	577.405

Descriptive statistics

Standard deviation	1659.887917
Coefficient of variation (CV)	2.801794753
Kurtosis	164.187572
Mean	592.4373709
Median Absolute Deviation (MAD)	38
Skewness	10.04508288
Sum	5302314.47
Variance	2755227.898
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4302	48.1%
45.65	46	0.5%
50	17	0.2%
200	15	0.2%
60	13	0.1%
100	13	0.1%
70	12	0.1%
150	12	0.1%
1000	12	0.1%
250	11	0.1%
Other values (4004)	4497	50.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4302	48.1%
0.01	7	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	4	< 0.1%
1.4	2	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

INSTALLMENTS_PURCHASES
Real number (ℝ_≥0)

ZEROS

Distinct	4452
Distinct (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	411.0676447
Minimum	0
Maximum	22500
Zeros	3916
Zeros (%)	43.8%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89
Q3	468.6375
95-th percentile	1750.0875
Maximum	22500
Range	22500
Interquartile range (IQR)	468.6375

Descriptive statistics

Standard deviation	904.3381152
Coefficient of variation (CV)	2.199973963
Kurtosis	96.57517753
Mean	411.0676447
Median Absolute Deviation (MAD)	89
Skewness	7.299119909
Sum	3679055.42
Variance	817827.4266
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3916	43.8%
100	14	0.2%
300	14	0.2%
200	14	0.2%
150	12	0.1%
125	11	0.1%
75	9	0.1%
225	8	0.1%
350	8	0.1%
450	8	0.1%
Other values (4442)	4936	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3916	43.8%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.28	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

CASH_ADVANCE
Real number (ℝ_≥0)

ZEROS

Distinct	4323
Distinct (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	978.8711125
Minimum	0
Maximum	47137.21176
Zeros	4628
Zeros (%)	51.7%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1113.821139
95-th percentile	4647.169122
Maximum	47137.21176
Range	47137.21176
Interquartile range (IQR)	1113.821139

Descriptive statistics

Standard deviation	2097.163877
Coefficient of variation (CV)	2.142431062
Kurtosis	52.89943411
Mean	978.8711125
Median Absolute Deviation (MAD)	0
Skewness	5.166609074
Sum	8760896.457
Variance	4398096.325
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
1286.356207	1	< 0.1%
3816.470266	1	< 0.1%
2495.298926	1	< 0.1%
748.241727	1	< 0.1%
1572.492719	1	< 0.1%
5425.912807	1	< 0.1%
9553.955906	1	< 0.1%
341.360876	1	< 0.1%
1424.442602	1	< 0.1%
Other values (4313)	4313	48.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

PURCHASES_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4903505484
Minimum	0
Maximum	1
Zeros	2043
Zeros (%)	22.8%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.4013707474
Coefficient of variation (CV)	0.8185383879
Kurtosis	-1.638630948
Mean	0.4903505484
Median Absolute Deviation (MAD)	0.416667
Skewness	0.06016423586
Sum	4388.637408
Variance	0.1610984768
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2178	24.3%
0	2043	22.8%
0.083333	677	7.6%
0.916667	396	4.4%
0.5	395	4.4%
0.166667	392	4.4%
0.833333	373	4.2%
0.333333	367	4.1%
0.25	345	3.9%
0.583333	316	3.5%
Other values (37)	1468	16.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2043	22.8%
0.083333	677	7.6%
0.090909	43	0.5%
0.1	27	0.3%
0.111111	18	0.2%
0.125	32	0.4%
0.142857	26	0.3%
0.166667	392	4.4%
0.181818	16	0.2%
0.2	19	0.2%

Value	Count	Frequency (%)
1	2178	24.3%
0.916667	396	4.4%
0.909091	28	0.3%
0.9	24	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	25	0.3%
0.833333	373	4.2%
0.818182	21	0.2%
0.8	9	0.1%

ONEOFF_PURCHASES_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2024576836
Minimum	0
Maximum	1
Zeros	4302
Zeros (%)	48.1%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.3
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.2983360652
Coefficient of variation (CV)	1.473572452
Kurtosis	1.161845601
Mean	0.2024576836
Median Absolute Deviation (MAD)	0.083333
Skewness	1.535612784
Sum	1811.996268
Variance	0.08900440779
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.166667	592	6.6%
1	481	5.4%
0.25	418	4.7%
0.333333	355	4.0%
0.416667	244	2.7%
0.5	235	2.6%
0.583333	197	2.2%
0.666667	167	1.9%
Other values (37)	855	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.090909	56	0.6%
0.1	39	0.4%
0.111111	26	0.3%
0.125	41	0.5%
0.142857	37	0.4%
0.166667	592	6.6%
0.181818	34	0.4%
0.2	27	0.3%

Value	Count	Frequency (%)
1	481	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	120	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

PURCHASES_INSTALLMENTS_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3644373416
Minimum	0
Maximum	1
Zeros	3915
Zeros (%)	43.7%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.3974477797
Coefficient of variation (CV)	1.090579187
Kurtosis	-1.398632185
Mean	0.3644373416
Median Absolute Deviation (MAD)	0.166667
Skewness	0.509201165
Sum	3261.714207
Variance	0.1579647376
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3915	43.7%
1	1331	14.9%
0.416667	388	4.3%
0.916667	345	3.9%
0.833333	311	3.5%
0.5	310	3.5%
0.166667	305	3.4%
0.666667	292	3.3%
0.75	291	3.3%
0.083333	275	3.1%
Other values (37)	1187	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3915	43.7%
0.083333	275	3.1%
0.090909	12	0.1%
0.1	6	0.1%
0.111111	9	0.1%
0.125	5	0.1%
0.142857	6	0.1%
0.166667	305	3.4%
0.181818	14	0.2%
0.2	9	0.1%

Value	Count	Frequency (%)
1	1331	14.9%
0.916667	345	3.9%
0.909091	25	0.3%
0.9	19	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	30	0.3%
0.833333	311	3.5%
0.818182	21	0.2%
0.8	18	0.2%

CASH_ADVANCE_FREQUENCY
Real number (ℝ_≥0)

ZEROS

Distinct	54
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1351442003
Minimum	0
Maximum	1.5
Zeros	4628
Zeros (%)	51.7%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.222222
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.222222

Descriptive statistics

Standard deviation	0.2001213881
Coefficient of variation (CV)	1.480798937
Kurtosis	3.334734328
Mean	0.1351442003
Median Absolute Deviation (MAD)	0
Skewness	1.828686266
Sum	1209.540593
Variance	0.04004856999
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.166667	759	8.5%
0.25	578	6.5%
0.333333	439	4.9%
0.416667	273	3.1%
0.5	215	2.4%
0.583333	142	1.6%
0.666667	125	1.4%
0.090909	70	0.8%
Other values (44)	700	7.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.090909	70	0.8%
0.1	39	0.4%
0.111111	29	0.3%
0.125	47	0.5%
0.142857	49	0.5%
0.166667	759	8.5%
0.181818	42	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	25	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%

CASH_ADVANCE_TRX
Real number (ℝ_≥0)

ZEROS

Distinct	65
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.248826816
Minimum	0
Maximum	123
Zeros	4628
Zeros (%)	51.7%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.824646744
Coefficient of variation (CV)	2.100649598
Kurtosis	61.64686248
Mean	3.248826816
Median Absolute Deviation (MAD)	0
Skewness	5.721298203
Sum	29077
Variance	46.57580318
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
10	150	1.7%
Other values (55)	915	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
9	111	1.2%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

PURCHASES_TRX
Real number (ℝ_≥0)

ZEROS

Distinct	173
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	14.7098324
Minimum	0
Maximum	358
Zeros	2044
Zeros (%)	22.8%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	17
95-th percentile	57
Maximum	358
Range	358
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	24.85764911
Coefficient of variation (CV)	1.689866236
Kurtosis	34.79310026
Mean	14.7098324
Median Absolute Deviation (MAD)	7
Skewness	4.630655266
Sum	131653
Variance	617.9027193
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
12	570	6.4%
2	379	4.2%
6	352	3.9%
3	314	3.5%
4	285	3.2%
7	275	3.1%
8	267	3.0%
5	267	3.0%
Other values (163)	3530	39.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
2	379	4.2%
3	314	3.5%
4	285	3.2%
5	267	3.0%
6	352	3.9%
7	275	3.1%
8	267	3.0%
9	248	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

CREDIT_LIMIT
Real number (ℝ_≥0)

Distinct	205
Distinct (%)	2.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	4494.44945
Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3638.815725
Coefficient of variation (CV)	0.8096243524
Kurtosis	2.836655932
Mean	4494.44945
Median Absolute Deviation (MAD)	1800
Skewness	1.522464005
Sum	40220828.13
Variance	13240979.88
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	784	8.8%
1500	722	8.1%
1200	621	6.9%
1000	614	6.9%
2500	612	6.8%
4000	506	5.7%
6000	463	5.2%
5000	389	4.3%
2000	371	4.1%
7500	277	3.1%
Other values (195)	3590	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	121	1.4%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

PAYMENTS
Real number (ℝ_≥0)

ZEROS

Distinct	8711
Distinct (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1733.143852
Minimum	0
Maximum	50721.48336
Zeros	240
Zeros (%)	2.7%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	89.98892395
Q1	383.276166
median	856.901546
Q3	1901.134317
95-th percentile	6082.090595
Maximum	50721.48336
Range	50721.48336
Interquartile range (IQR)	1517.858151

Descriptive statistics

Standard deviation	2895.063757
Coefficient of variation (CV)	1.670411693
Kurtosis	54.77073581
Mean	1733.143852
Median Absolute Deviation (MAD)	581.3514605
Skewness	5.907619794
Sum	15511637.48
Variance	8381394.157
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	240	2.7%
806.587482	1	< 0.1%
836.812414	1	< 0.1%
139.607827	1	< 0.1%
107.242408	1	< 0.1%
433.860714	1	< 0.1%
402.20014	1	< 0.1%
308.886492	1	< 0.1%
238.695115	1	< 0.1%
197.86349	1	< 0.1%
Other values (8701)	8701	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	240	2.7%
0.049513	1	< 0.1%
0.056466	1	< 0.1%
2.389583	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
5.070726	1	< 0.1%
9.040017	1	< 0.1%
9.533313	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

MINIMUM_PAYMENTS
Real number (ℝ_≥0)

MISSING

Distinct	8636
Distinct (%)	> 99.9%
Missing	313
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%

Mean	864.2065423
Minimum	0.019163
Maximum	76406.20752
Zeros	0
Zeros (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	73.2820058
Q1	169.123707
median	312.343947
Q3	825.485459
95-th percentile	2766.56331
Maximum	76406.20752
Range	76406.18836
Interquartile range (IQR)	656.361752

Descriptive statistics

Standard deviation	2372.446607
Coefficient of variation (CV)	2.745231019
Kurtosis	283.9899859
Mean	864.2065423
Median Absolute Deviation (MAD)	190.374096
Skewness	13.62279699
Sum	7464151.906
Variance	5628502.901
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
299.351881	2	< 0.1%
284.70693	1	< 0.1%
144.641814	1	< 0.1%
1927.887547	1	< 0.1%
6825.44203	1	< 0.1%
342.412476	1	< 0.1%
5583.630482	1	< 0.1%
125.3494	1	< 0.1%
3.19794	1	< 0.1%
140.596138	1	< 0.1%
Other values (8626)	8626	96.4%
(Missing)	313	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
1.334075	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

PRC_FULL_PAYMENT
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1537146485
Minimum	0
Maximum	1
Zeros	5903
Zeros (%)	66.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.142857
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.142857

Descriptive statistics

Standard deviation	0.2924991962
Coefficient of variation (CV)	1.902871321
Kurtosis	2.432395301
Mean	0.1537146485
Median Absolute Deviation (MAD)	0
Skewness	1.942819941
Sum	1375.746104
Variance	0.0855557798
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5903	66.0%
1	488	5.5%
0.083333	426	4.8%
0.166667	166	1.9%
0.25	156	1.7%
0.5	156	1.7%
0.090909	153	1.7%
0.333333	134	1.5%
0.1	94	1.1%
0.2	83	0.9%
Other values (37)	1191	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5903	66.0%
0.083333	426	4.8%
0.090909	153	1.7%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.8%
0.2	83	0.9%

Value	Count	Frequency (%)
1	488	5.5%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	63	0.7%
0.818182	17	0.2%
0.8	33	0.4%

TENURE
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.51731844
Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.338330769
Coefficient of variation (CV)	0.1162015947
Kurtosis	7.694823186
Mean	11.51731844
Median Absolute Deviation (MAD)	0
Skewness	-2.943017288
Sum	103080
Variance	1.791129248
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
6	204	2.3%
8	196	2.2%
7	190	2.1%
9	175	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	204	2.3%
7	190	2.1%
8	196	2.2%
9	175	2.0%
10	236	2.6%
11	365	4.1%
12	7584	84.7%

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
9	175	2.0%
8	196	2.2%
7	190	2.1%
6	204	2.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	CUST_ID	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	CREDIT_LIMIT	PAYMENTS	MINIMUM_PAYMENTS	PRC_FULL_PAYMENT	TENURE
0	C10001	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.000000	0	2	1000.0	201.802084	139.509787	0.000000	12
1	C10002	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.250000	4	0	7000.0	4103.032597	1072.340217	0.222222	12
2	C10003	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.000000	0	12	7500.0	622.066742	627.284787	0.000000	12
3	C10004	1666.670542	0.636364	1499.00	1499.00	0.00	205.788017	0.083333	0.083333	0.000000	0.083333	1	1	7500.0	0.000000	NaN	0.000000	12
4	C10005	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.000000	0	1	1200.0	678.334763	244.791237	0.000000	12
5	C10006	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.000000	0	8	1800.0	1400.057770	2407.246035	0.000000	12
6	C10007	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.000000	0	64	13500.0	6354.314328	198.065894	1.000000	12
7	C10008	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.000000	0	12	2300.0	679.065082	532.033990	0.000000	12
8	C10009	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.000000	0	5	7000.0	688.278568	311.963409	0.000000	12
9	C10010	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	3	11000.0	1164.770591	100.302262	0.000000	12

Last rows

	CUST_ID	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	CREDIT_LIMIT	PAYMENTS	MINIMUM_PAYMENTS	PRC_FULL_PAYMENT	TENURE
8940	C19181	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.00	6
8941	C19182	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.00	6
8942	C19183	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.25	6
8943	C19184	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.00	6
8944	C19185	193.571722	0.833333	1012.73	1012.73	0.00	0.000000	0.333333	0.333333	0.000000	0.000000	0	2	4000.0	0.000000	NaN	0.00	6
8945	C19186	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.50	6
8946	C19187	19.183215	1.000000	300.00	0.00	300.00	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	275.861322	NaN	0.00	6
8947	C19188	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.25	6
8948	C19189	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	500.0	52.549959	55.755628	0.25	6
8949	C19190	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.00	6

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows